SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbfamilia
AS
SELECT     dbo.tb_Familia.Alumno, dbo.tb_Familia.Documento, dbo.tb_Familia.Apellido, dbo.tb_Familia.Nombres, dbo.tb_Parentezcos.Descripcion, 
                      dbo.tb_Familia.ViveConElAlumno
FROM         dbo.tb_Familia INNER JOIN
                      dbo.tb_Parentezcos ON dbo.tb_Familia.Parentesco = dbo.tb_Parentezcos.idParentezco
GO
GRANT SELECT ON  [dbo].[vwbfamilia] TO [Alumnos]
GRANT SELECT ON  [dbo].[vwbfamilia] TO [GestionInstitucional]
GRANT SELECT ON  [dbo].[vwbfamilia] TO [SoloVer]
GO
